>> I hadn't considered the possibility of the entire table data being in
>> the index itself. That would move the tipping point somewhat...
> 
> Not the entire table, just the columns required by the query in question.

Right, that's the other point I overlooked - you might not actually want 
every single column in the table for a given query.

So, now that we've got all that out of the way, I'm sure you'll agree 
with me that there are times when you do *not* want to use an index, 
even if there is one. ;-)

-- 
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*

Post a reply to this message